package counsel;

public class CounselDTO {
	
	private String cs_no="";		//상담 번호
	private String sa_no="";		//사원 번호
	private String pd_no="";		//상품 번호
	private String cs_content;		//상담 내용
	private String cs_loan;			//대출 신청액
	private String cs_max;			//대출 한도
	private String sa_dpm;			//부서
	private String sa_gd;			//작책
	private String pd_pback;		//납입 구분코드
	private String pd_rate;			//금리
	private String pd_prd;			//상환 기간
	private String rg_pp;			//최초 등록자
	private String rg_dt;			//최초 등록일
	private String md_pp;			//최종 수정자
	private String md_dt;			//최종 수정일
	
	//다른 테이블 컬럼 변수(목록용)
	private String sa_nm;
	private String pd_nm;
	private String ct_ing;
	private String sa_home;
	private String sa_car;
	private String sa_marr;
	private String sa_hd;
	private String pd_min;
	private String pd_max;
	private String pd_yn;
	//다른 테이블 컬럼 변수(수정용)
	private String sa_sx;
	private String sa_age;
	//검색용 변수
	private String sa_search;//사원명인지 사원번호인지
	private String pd_search;//상품명인지 상품번호인지
	private String cs_search;//상담번호인지 담당자인지
	private String cs_sd;//상담일검색 시작일
	private String cs_ed;//상담일검색 마지막일
	private String full;//검색인지 아닌지 구분하기 위해
	//화면 표시용
	private String rg_pp_nm;
	//생성자
	public CounselDTO() {}
	
	//insert용 생성자
	public CounselDTO(String cs_no, String sa_no, String pd_no,
			String cs_content, String cs_loan, String cs_max, String sa_dpm,
			String sa_gd, String pd_pback, String pd_rate, String pd_prd,
			String rg_pp, String md_pp) {
		this.cs_no = cs_no;
		this.sa_no = sa_no;
		this.pd_no = pd_no;
		this.cs_content = cs_content;
		this.cs_loan = cs_loan;
		this.cs_max = cs_max;
		this.sa_dpm = sa_dpm;
		this.sa_gd = sa_gd;
		this.pd_pback = pd_pback;
		this.pd_rate = pd_rate;
		this.pd_prd = pd_prd;
		this.rg_pp = rg_pp;
		this.md_pp = md_pp;
	}
	
	//update용 생성자
	public CounselDTO(String cs_no, String pd_no, String cs_loan, String cs_content,
			String pd_pback, String pd_rate, String pd_prd, String md_pp) {
		this.cs_no = cs_no;
		this.pd_no = pd_no;
		this.cs_loan = cs_loan;
		this.cs_content = cs_content;
		this.pd_pback = pd_pback;
		this.pd_rate = pd_rate;
		this.pd_prd = pd_prd;
		this.md_pp = md_pp;
	}
	
	//getter/setter
	public String getCs_no() {
		return cs_no;
	}
	public void setCs_no(String cs_no) {
		this.cs_no = cs_no;
	}
	public String getSa_no() {
		return sa_no;
	}
	public void setSa_no(String sa_no) {
		this.sa_no = sa_no;
	}
	public String getPd_no() {
		return pd_no;
	}
	public void setPd_no(String pd_no) {
		this.pd_no = pd_no;
	}
	public String getCs_content() {
		return cs_content;
	}
	public void setCs_content(String cs_content) {
		this.cs_content = cs_content;
	}
	public String getCs_loan() {
		return cs_loan;
	}
	public void setCs_loan(String cs_loan) {
		this.cs_loan = cs_loan;
	}
	public String getCs_max() {
		return cs_max;
	}
	public void setCs_max(String cs_max) {
		this.cs_max = cs_max;
	}
	public String getSa_dpm() {
		return sa_dpm;
	}
	public void setSa_dpm(String sa_dpm) {
		this.sa_dpm = sa_dpm;
	}
	public String getSa_gd() {
		return sa_gd;
	}
	public void setSa_gd(String sa_gd) {
		this.sa_gd = sa_gd;
	}
	public String getPd_pback() {
		return pd_pback;
	}
	public void setPd_pback(String pd_pback) {
		this.pd_pback = pd_pback;
	}
	public String getPd_rate() {
		return pd_rate;
	}
	public void setPd_rate(String pd_rate) {
		this.pd_rate = pd_rate;
	}
	public String getPd_prd() {
		return pd_prd;
	}
	public void setPd_prd(String pd_prd) {
		this.pd_prd = pd_prd;
	}
	public String getRg_pp() {
		return rg_pp;
	}
	public void setRg_pp(String rg_pp) {
		this.rg_pp = rg_pp;
	}
	public String getRg_dt() {
		return rg_dt;
	}
	public void setRg_dt(String rg_dt) {
		this.rg_dt = rg_dt;
	}
	public String getMd_pp() {
		return md_pp;
	}
	public void setMd_pp(String md_pp) {
		this.md_pp = md_pp;
	}
	public String getMd_dt() {
		return md_dt;
	}
	public void setMd_dt(String md_dt) {
		this.md_dt = md_dt;
	}

	//다른 테이블 getter/setter
	public String getSa_nm() {
		return sa_nm;
	}
	public void setSa_nm(String sa_nm) {
		this.sa_nm = sa_nm;
	}
	public String getPd_nm() {
		return pd_nm;
	}
	public void setPd_nm(String pd_nm) {
		this.pd_nm = pd_nm;
	}
	public String getCt_ing() {
		return ct_ing;
	}
	public void setCt_ing(String ct_ing) {
		this.ct_ing = ct_ing;
	}
	public String getSa_home() {
		return sa_home;
	}
	public void setSa_home(String sa_home) {
		this.sa_home = sa_home;
	}
	public String getSa_car() {
		return sa_car;
	}
	public void setSa_car(String sa_car) {
		this.sa_car = sa_car;
	}
	public String getSa_marr() {
		return sa_marr;
	}
	public void setSa_marr(String sa_marr) {
		this.sa_marr = sa_marr;
	}
	public String getSa_hd() {
		return sa_hd;
	}
	public void setSa_hd(String sa_hd) {
		this.sa_hd = sa_hd;
	}
	public String getPd_min() {
		return pd_min;
	}
	public void setPd_min(String pd_min) {
		this.pd_min = pd_min;
	}
	public String getPd_max() {
		return pd_max;
	}
	public void setPd_max(String pd_max) {
		this.pd_max = pd_max;
	}
	public String getPd_yn() {
		return pd_yn;
	}
	public void setPd_yn(String pd_yn) {
		this.pd_yn = pd_yn;
	}
	public String getSa_sx() {
		return sa_sx;
	}
	public void setSa_sx(String sa_sx) {
		this.sa_sx = sa_sx;
	}
	public String getSa_age() {
		return sa_age;
	}
	public void setSa_age(String sa_age) {
		this.sa_age = sa_age;
	}
	
	//검색용 getter/setter
	public String getSa_search() {
		return sa_search;
	}
	public void setSa_search(String sa_search) {
		this.sa_search = sa_search;
	}
	public String getPd_search() {
		return pd_search;
	}
	public void setPd_search(String pd_search) {
		this.pd_search = pd_search;
	}
	public String getCs_search() {
		return cs_search;
	}
	public void setCs_search(String cs_search) {
		this.cs_search = cs_search;
	}
	public String getCs_sd() {
		return cs_sd;
	}
	public void setCs_sd(String cs_sd) {
		this.cs_sd = cs_sd;
	}
	public String getCs_ed() {
		return cs_ed;
	}
	public void setCs_ed(String cs_ed) {
		this.cs_ed = cs_ed;
	}
	public String getFull() {
		return full;
	}
	public void setFull(String full) {
		this.full = full;
	}
	public String getRg_pp_nm() {
		return rg_pp_nm;
	}
	public void setRg_pp_nm(String rg_pp_nm) {
		this.rg_pp_nm = rg_pp_nm;
	}
	
}
